package com.trkj.dao.wxy;

import java.util.List;

import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.AuxiliaryInformation;

public interface AuxiliaryInformationDao extends CrudRepository<AuxiliaryInformation, Long> {
	//多表查询分页
	@Query("select a,s from AuxiliaryInformation a inner join a.skill s")
	public List<Object[]> queryByExamAssistData(Pageable p);

}
